USE [RpcExtendService]
GO
INSERT [dbo].[AutoTaskItem] ([Id], [TaskId], [ItemTitle], [ItemSort], [SendType], [SendParam], [TimeOut], [RetryNum], [FailSetup], [FailNextSetup], [SuccessSetup], [NextSetup], [IsWriteLog], [IsSuccess], [ErrorCode], [IsEnable]) VALUES (N'36e02ff2-32d5-4363-9e30-a6d2bca64f3d', N'a5a0a296-d186-4ea3-8c49-0b29e33229d9', N'检查超时事务', 2, 0, N'{"RpcConfig":{"SendConfig":{"SysDictate":"CheckOverTimeTran","IsReply":false},"RpcMerId":1,"SystemType":"sys.sync"}}', 10, 2, 1, NULL, 1, NULL, 0, 1, 0, 1)
GO
INSERT [dbo].[AutoTaskItem] ([Id], [TaskId], [ItemTitle], [ItemSort], [SendType], [SendParam], [TimeOut], [RetryNum], [FailSetup], [FailNextSetup], [SuccessSetup], [NextSetup], [IsWriteLog], [IsSuccess], [ErrorCode], [IsEnable]) VALUES (N'36e02ff2-32d5-4363-9e30-a6d2bca64f3e', N'a5a0a296-d186-4ea3-8c49-0b29e33229d9', N'事务回滚超时检查', 3, 0, N'{"RpcConfig":{"SendConfig":{"SysDictate":"TranLockOverTime","IsReply":false},"RpcMerId":1,"SystemType":"sys.sync"}}', 10, 2, 1, NULL, 1, NULL, 0, 1, 0, 1)
GO
INSERT [dbo].[AutoTaskItem] ([Id], [TaskId], [ItemTitle], [ItemSort], [SendType], [SendParam], [TimeOut], [RetryNum], [FailSetup], [FailNextSetup], [SuccessSetup], [NextSetup], [IsWriteLog], [IsSuccess], [ErrorCode], [IsEnable]) VALUES (N'36e02ff2-32d5-4363-9e30-a6d2bca64f4a', N'a5a0a296-d186-4ea3-8c49-0b29e33229d9', N'重启回滚失败的事务', 4, 0, N'{"RpcConfig":{"SendConfig":{"SysDictate":"RestartRetryTran","IsReply":false},"RpcMerId":1,"SystemType":"sys.sync"}}', 10, 2, 0, NULL, 0, NULL, 0, 1, 0, 1)
GO
INSERT [dbo].[AutoTaskItem] ([Id], [TaskId], [ItemTitle], [ItemSort], [SendType], [SendParam], [TimeOut], [RetryNum], [FailSetup], [FailNextSetup], [SuccessSetup], [NextSetup], [IsWriteLog], [IsSuccess], [ErrorCode], [IsEnable]) VALUES (N'b41ff120-1482-4942-b968-c480886861df', N'48e4c47d-3e85-4fde-b0ff-beb96ada17d0', N'清理已删除的资源', 2, 0, N'{"RpcConfig":{"SendConfig":{"SysDictate":"ClearResource","IsReply":false},"SystemType":"sys.sync","RpcMerId":1}}', 10, 2, 0, NULL, 0, NULL, 0, 0, NULL, 1)
GO
INSERT [dbo].[AutoTaskItem] ([Id], [TaskId], [ItemTitle], [ItemSort], [SendType], [SendParam], [TimeOut], [RetryNum], [FailSetup], [FailNextSetup], [SuccessSetup], [NextSetup], [IsWriteLog], [IsSuccess], [ErrorCode], [IsEnable]) VALUES (N'421bca27-f7fd-4911-a70b-d1dbb72c5541', N'48e4c47d-3e85-4fde-b0ff-beb96ada17d0', N'标记待删除的资源', 1, 0, N'{"RpcConfig":{"SendConfig":{"SysDictate":"InvalidResource","IsReply":false},"SystemType":"sys.sync","RpcMerId":1}}', 10, 2, 1, NULL, 1, NULL, 0, 0, NULL, 1)
GO
INSERT [dbo].[AutoTaskList] ([Id], [RegionId], [TaskName], [TaskShow], [TaskPriority], [BeginItem], [FailEmall], [VerNum], [IsExec], [ExecVerNum], [LastExecTime], [LastExecEndTime], [NextExecTime], [IsEnable]) VALUES (N'a5a0a296-d186-4ea3-8c49-0b29e33229d9', 1, N'分布式事务', N'1，检查超时事务 2，事务回滚重试', 0, 1, NULL, 0, 0, 1262901233, CAST(N'2022-02-14T22:21:35.213' AS DateTime), CAST(N'2022-02-14T22:21:35.473' AS DateTime), CAST(N'2022-02-14T22:21:45.213' AS DateTime), 1)
GO
INSERT [dbo].[AutoTaskList] ([Id], [RegionId], [TaskName], [TaskShow], [TaskPriority], [BeginItem], [FailEmall], [VerNum], [IsExec], [ExecVerNum], [LastExecTime], [LastExecEndTime], [NextExecTime], [IsEnable]) VALUES (N'48e4c47d-3e85-4fde-b0ff-beb96ada17d0', 1, N'接口资源管理', N'1，标记待删除的资源 2，清理已删除的资源', 1, 1, NULL, 0, 0, 0, NULL, NULL, CAST(N'2022-01-17T00:01:00.000' AS DateTime), 1)
GO
INSERT [dbo].[AutoTaskPlan] ([Id], [TaskId], [PlanTitle], [PlanType], [ExecTime], [ExecRate], [ExecSpace], [SpaceType], [SpaceDay], [SpeceNum], [SpaceWeek], [DayRate], [DayTimeSpan], [DaySpaceType], [DaySpaceNum], [DayBeginSpan], [DayEndSpan], [BeginDate], [EndDate], [PlanOnlyNo], [ErrorCode], [IsEnable]) VALUES (N'9c0fa699-ec2c-46b0-9979-ba48f50ba401', N'a5a0a296-d186-4ea3-8c49-0b29e33229d9', N'每隔10秒钟执行', 0, NULL, 0, 1, 0, NULL, NULL, NULL, 1, 10, 0, 10, 0, 86399, CAST(N'2022-01-16' AS Date), NULL, NULL, NULL, 1)
GO
INSERT [dbo].[AutoTaskPlan] ([Id], [TaskId], [PlanTitle], [PlanType], [ExecTime], [ExecRate], [ExecSpace], [SpaceType], [SpaceDay], [SpeceNum], [SpaceWeek], [DayRate], [DayTimeSpan], [DaySpaceType], [DaySpaceNum], [DayBeginSpan], [DayEndSpan], [BeginDate], [EndDate], [PlanOnlyNo], [ErrorCode], [IsEnable]) VALUES (N'cdaefa7d-86cc-4f8a-9a8f-c7bdb3370daa', N'48e4c47d-3e85-4fde-b0ff-beb96ada17d0', N'每天0点1分钟执行一次', 0, NULL, 0, 1, 0, NULL, NULL, NULL, 0, 60, 0, NULL, NULL, NULL, CAST(N'2022-01-16' AS Date), NULL, NULL, NULL, 1)
GO
